Excel 2003 - Consolidating Workbooks, Linking Data, Outlining and Excel Workspaces
      The "Excel 2003 - Consolidating Workbooks, Linking Data, Outlining and Excel Workspaces" lesson covers the following topics:
  • Saving a Workspace
  • Linking Workbooks
  • Outlining
  • Consolidating Workbooks
      
      Saving a Workspace      
      Upon successful completion you will be able to:

1. Apply File Selection Techniques;
2. De-select Files;
3. Open Multiple Files;
4. Move Between Open Workbooks;
5. Arrange Workbooks on Screen;
6. Save a Workspace File;
7. Use Workspace Files;
8. Close Multiple Workbooks.
      
      Linking Workbooks      
      Upon successful completion you will be able to:

1. Compare Paste & Paste Special Commands;
2. Use the Paste Special Command;
3. Create a Link Between Workbook Data;
4. Update Linked Information.
      
      Outlining      
      Upon successful completion you will be able to:

1. Automatically Outline a Worksheet;
2. Decrease & Expand Outline Details;
3. Select Details in an Outline;
4. Remove Outlining Levels;
5. Manually Group Details;
6. Remove a Group Outline.
      
      Consolidating Workbooks      
      Upon successful completion you will be able to:

1. Consolidate Workbooks;
2. Select Destination Cells;
3. Add Source Data References;
4. Create Source Data Links;
5. Work with Consolidated File Outlines.
      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2003 - Consolidating Workbooks, Linking Data, Outlining and Excel Workspaces :
Program Training Courses - Microsoft Excel 2003 :
Office Suite Training Courses - Microsoft Office 2003 :
© 2017 Online Training Masters